package com.njust.mapper;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.njust.domain.dto.TrainCreateCertificateDTO;
import com.njust.domain.dto.TrainDownloadCertDTO;
import com.njust.domain.po.TrainTestPaper;
import org.apache.ibatis.annotations.Select;

public interface TrainTestPaperMapper extends BaseMapper<TrainTestPaper> {
    @Select("select user.uName as uName, product.product_name as productName,project.standard_number as standardNumber,  project.project_name as projectName from personnel_capabilitie inner join user on personnel_capabilitie.uId = user.uId inner join project on personnel_capabilitie.project_id = project.project_id inner join product on product.product_id = project.product_id where personnel_capabilitie.uId = #{uId} and personnel_capabilitie.project_id = #{project_id};")
    public TrainCreateCertificateDTO createCertificate(int uId,int project_id);

}
